CREATE external TABLE jms_ods.`sys_network_delivery_log` (
  `id` int  COMMENT '主键id',
  `network_id` int  COMMENT '网点ID',
  `delivery_points` string  COMMENT '可交货集散点集合',
  `delivery_transfer_centers` string ,
  `distribution_points` string  COMMENT '可派货集散点集合',
  `delivery_centers` string ,
  `delivery_id` int  COMMENT '主交货关系Id',
  `delivery_relationship_id` int  COMMENT '主派货关系Id',
  `is_distribution` int  COMMENT '是否集散 1是 2否',
  `create_by` int  COMMENT '创建人ID',
  `create_by_name` string  COMMENT '创建人名称',
  `create_time` string  COMMENT '创建时间',
  `update_time` string  COMMENT '更新时间',
  `is_latest` int  COMMENT '是否最新 1是 2否',
  `staff_code` string  COMMENT '修改员工编号'
)COMMENT  '网点-交货关系变更表'
PARTITIONED BY (dt string COMMENT '更新/创建日期 (yyyy-MM-dd)')
stored as parquet
LOCATION '/dw/hive/jms_ods.db/external/sys_network_delivery_log';